/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : briup-am

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 04/01/2022 18:19:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for am_device
-- ----------------------------
DROP TABLE IF EXISTS `am_device`;
CREATE TABLE `am_device` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `serial_number` varchar(255) NOT NULL COMMENT '设备编号',
  `bind_status` bigint(20) NOT NULL COMMENT '绑定状态',
  `online_status` bigint(20) NOT NULL COMMENT '在线状态',
  `latitude` varchar(255) DEFAULT NULL COMMENT '经度',
  `timer` bigint(20) DEFAULT NULL COMMENT '定时器id',
  `longitude` varchar(255) DEFAULT NULL COMMENT '纬度',
  `insert_time` bigint(20) DEFAULT NULL COMMENT '插入时间',
  `video` varchar(255) DEFAULT NULL COMMENT '视频地址',
  `engineer_id` bigint(20) DEFAULT NULL COMMENT '所属工程ID',
  PRIMARY KEY (`id`),
  KEY `enginner_id` (`engineer_id`),
  KEY `name` (`name`),
  CONSTRAINT `am_device_ibfk_1` FOREIGN KEY (`engineer_id`) REFERENCES `am_engineer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of am_device
-- ----------------------------
BEGIN;
INSERT INTO `am_device` VALUES (1, '一号设备', 'DV_20210002', 1, 1, '103.699249', 114, '36.091265', 1639969918785, 'http://8.130.16.184/vv.mov', 2);
INSERT INTO `am_device` VALUES (2, '二号设备', 'DV_20210001', 1, 1, '103.700226', 103, '36.090181', 1639969927152, 'http://8.130.16.184/vv.mov', 2);
INSERT INTO `am_device` VALUES (3, '三号设备', 'DV_20210003', 1, 1, '103.698965', 8472, '36.090771', 1639969946535, 'http://8.130.16.184/vv.mov', 1);
INSERT INTO `am_device` VALUES (4, '四号设备', 'DV_20210004', 0, 0, NULL, NULL, NULL, 1639969953486, NULL, NULL);
INSERT INTO `am_device` VALUES (5, '五号设备', 'DV_20210005', 0, 0, NULL, NULL, NULL, 1639969960815, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for am_engineer
-- ----------------------------
DROP TABLE IF EXISTS `am_engineer`;
CREATE TABLE `am_engineer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `serial_number` varchar(255) NOT NULL COMMENT '工程编号',
  `name` varchar(255) NOT NULL COMMENT '工程名称',
  `status` varchar(255) DEFAULT NULL COMMENT '工程状态',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `type` varchar(255) NOT NULL COMMENT '工程类型',
  `latitude` varchar(255) DEFAULT NULL COMMENT '经度',
  `longitude` varchar(255) DEFAULT NULL COMMENT '纬度',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `begin_time` bigint(20) DEFAULT NULL COMMENT '工程开始时间',
  `end_time` bigint(20) DEFAULT NULL COMMENT '工程结束时间',
  `charge_id` bigint(20) DEFAULT NULL COMMENT '负责人ID',
  `customer_id` bigint(20) DEFAULT NULL COMMENT '顾客ID',
  PRIMARY KEY (`id`),
  KEY `charge_id` (`charge_id`),
  KEY `customer_id` (`customer_id`),
  KEY `name` (`name`),
  CONSTRAINT `am_engineer_ibfk_1` FOREIGN KEY (`charge_id`) REFERENCES `base_account` (`id`),
  CONSTRAINT `am_engineer_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `base_account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of am_engineer
-- ----------------------------
BEGIN;
INSERT INTO `am_engineer` VALUES (1, 'GC_20210001', '山西农大主体育场工程', '监测中', '甘肃省兰州市 undefined', '事业单位', '37.423954', '112.583804', 1639970383926, NULL, NULL, 2, 35);
INSERT INTO `am_engineer` VALUES (2, 'GC_20210002', '太原理工大学一号教学楼工程', '监测中', '山西省 太原市 杏花岭区 迎泽西大街79号', '事业单位', '37.861366', '112.522526', 1639970572966, NULL, NULL, 2, 36);
INSERT INTO `am_engineer` VALUES (3, 'GC_20210003', '中北大学', '未绑定', '山西省 太原市 尖草坪区 学院路3号', '事业单位', '38.015111', '112.447763', 1639988508609, NULL, NULL, 2, 37);
COMMIT;

-- ----------------------------
-- Table structure for am_monitor
-- ----------------------------
DROP TABLE IF EXISTS `am_monitor`;
CREATE TABLE `am_monitor` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `insert_time` bigint(20) DEFAULT NULL COMMENT '数据插入时间',
  `tsp` varchar(255) DEFAULT NULL COMMENT '总悬浮颗粒物',
  `pm10` varchar(255) DEFAULT NULL,
  `pm25` varchar(255) DEFAULT NULL,
  `noise` varchar(255) DEFAULT NULL COMMENT '噪声',
  `temperature` varchar(255) DEFAULT NULL COMMENT '温度',
  `humidity` varchar(255) DEFAULT NULL COMMENT '湿度',
  `wind_speed` varchar(255) DEFAULT NULL COMMENT '风速',
  `wind_direction` varchar(255) DEFAULT NULL COMMENT '风向',
  `engineer_id` bigint(20) DEFAULT NULL COMMENT '所属工程ID',
  `device_id` bigint(20) DEFAULT NULL COMMENT '所属设备ID',
  PRIMARY KEY (`id`),
  KEY `engineer_id` (`engineer_id`),
  KEY `device_id` (`device_id`),
  CONSTRAINT `am_monitor_ibfk_1` FOREIGN KEY (`engineer_id`) REFERENCES `am_engineer` (`id`),
  CONSTRAINT `am_monitor_ibfk_2` FOREIGN KEY (`device_id`) REFERENCES `am_device` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for am_workorder
-- ----------------------------
DROP TABLE IF EXISTS `am_workorder`;
CREATE TABLE `am_workorder` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '工单类型',
  `status` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '工单状态',
  `create_time` bigint(20) NOT NULL,
  `bill_why` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '工单生成原因',
  `finish_time` bigint(20) DEFAULT NULL COMMENT '工单处理完毕时间',
  `finish_note` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '工单处理完毕备注',
  `photo1` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '结束工单照片1',
  `photo2` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '结束工单照片2',
  `photo3` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '结束工单照片3',
  `engineer_id` bigint(20) DEFAULT NULL COMMENT '工程ID',
  `device_id` bigint(20) DEFAULT NULL COMMENT '设备ID',
  `account_id` bigint(20) DEFAULT NULL COMMENT '工人账号ID',
  `p1` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '生成工单照片1',
  `p2` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '生成工单照片2',
  `p3` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '生成工单照片3',
  PRIMARY KEY (`id`),
  KEY `engineer_id` (`engineer_id`),
  KEY `device_id` (`device_id`),
  KEY `account_id` (`account_id`),
  CONSTRAINT `am_workorder_ibfk_1` FOREIGN KEY (`engineer_id`) REFERENCES `am_engineer` (`id`),
  CONSTRAINT `am_workorder_ibfk_2` FOREIGN KEY (`device_id`) REFERENCES `am_device` (`id`),
  CONSTRAINT `am_workorder_ibfk_3` FOREIGN KEY (`account_id`) REFERENCES `base_account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of am_workorder
-- ----------------------------
BEGIN;
INSERT INTO `am_workorder` VALUES (1, '安装', '已完成', 1639972025041, NULL, 1640053594458, NULL, 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO1CAf42mAABq2BdUUMI627.jpg', 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO1KAOdjrAAAe9thEO8Y251.jpg', 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO1WAetE6AABMxFgBI4s958.jpg', 2, 1, 38, NULL, NULL, NULL);
INSERT INTO `am_workorder` VALUES (2, '安装', '进行中', 1639972578005, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, 1, NULL, NULL, NULL);
INSERT INTO `am_workorder` VALUES (3, '安装', '进行中', 1639987536424, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, NULL, NULL);
INSERT INTO `am_workorder` VALUES (4, '维修', '进行中', 1639989242356, '外壳损坏', NULL, NULL, NULL, NULL, NULL, 1, 3, 1, NULL, NULL, NULL);
INSERT INTO `am_workorder` VALUES (5, '维修', '已完成', 1640051646918, '无法采集数据', 1640053703574, NULL, 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO8CAMM_2AABq2BdUUMI668.jpg', 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO8OAKN8RAAAe9thEO8Y816.jpg', 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBO8WAPS7oAABMxFgBI4s353.jpg', 2, 1, 38, NULL, NULL, NULL);
INSERT INTO `am_workorder` VALUES (6, '维修', '进行中', 1640053966052, '摄像头故障', NULL, NULL, NULL, NULL, NULL, 1, 3, 38, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for base_account
-- ----------------------------
DROP TABLE IF EXISTS `base_account`;
CREATE TABLE `base_account` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `realname` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL COMMENT '性别',
  `birth` bigint(20) DEFAULT NULL,
  `user_face` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `register_time` bigint(20) NOT NULL COMMENT '注册时间',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`),
  KEY `base_account_ibfk_1` (`role_id`),
  CONSTRAINT `base_account_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `base_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_account
-- ----------------------------
BEGIN;
INSERT INTO `base_account` VALUES (1, 'admin', '123321', '张明', '13466779980', 'male', 1638350673589, 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWG3Zr-AA3PUAAAyUQ2W3FM62.jpeg', '正常', 1638344609075, 1);
INSERT INTO `base_account` VALUES (2, 'lerry', '123321', '李丽', '13566457783', 'male', 1638344609075, 'http://121.199.29.84:8888/group1/M00/00/13/rBD-SV-gGM6Ad_nNAALz1utokUc055.jpg', '正常', 1638350673589, 3);
INSERT INTO `base_account` VALUES (12, '康康', '123321', '康康1', '155645634326', 'male', 1639324800000, 'http://121.199.29.84:8888/group1/M00/00/9F/rBD-SWGxnIuAWUxOAAC1dUCi6FI709.png', '正常', 1638786597243, 4);
INSERT INTO `base_account` VALUES (17, 'moon', '123321', '李丽丽', '13466457789', 'male', 1638501668835, 'http://121.199.29.84:8888/group1/M00/00/9F/rBD-SWGxuE-AEUI6AADskB4isfQ992.jpg', '正常', 1638788311170, 4);
INSERT INTO `base_account` VALUES (21, 'Terry', '123321', '张三', '13466457789', 'female', 1638501668835, 'http://121.199.29.84:8888/group1/M00/00/9F/rBD-SWGxnHqAagWoAAEQLTBSqH4401.png', '正常', 1638950982465, 3);
INSERT INTO `base_account` VALUES (23, 'customer1', '123321', '吴老板', '13466457789', 'male', 1640620800000, 'http://121.199.29.84:8888/group1/M00/00/9F/rBD-SWGx0XyATzzbAAJKhFZ5wpA949.png', '正常', 1638959211571, 4);
INSERT INTO `base_account` VALUES (26, 'kangkang', '123321', '康康2', '15536332698', 'male', 1639411200000, 'http://xxx/xxxx111.jpg', '正常', 1639099623706, 1);
INSERT INTO `base_account` VALUES (27, 'larry', '123321', '李阳', '13466457789', 'male', 1638501668835, 'http://xxx/xxx.jgp', '正常', 1639103357218, 1);
INSERT INTO `base_account` VALUES (28, 'jacky', '123321', '王力宏', '15677890345', 'male', 1639117644649, 'http://xxx/xxxx.jpg', '正常', 1639117644649, 3);
INSERT INTO `base_account` VALUES (29, '张三', '123321', '张三', '13465789988', NULL, NULL, NULL, '正常', 1639126660575, 4);
INSERT INTO `base_account` VALUES (30, '王大山', '123321', '王大山', '13455667788', NULL, NULL, NULL, '正常', 1639126963201, 4);
INSERT INTO `base_account` VALUES (32, '陈乔年', '123321', '陈乔年', '18801010202', NULL, NULL, NULL, '正常', 1639386173746, 4);
INSERT INTO `base_account` VALUES (33, '赵刚', '123321', '赵刚', '15833467809', NULL, NULL, NULL, '正常', 1639398710343, 4);
INSERT INTO `base_account` VALUES (34, '张三', '123321', '张三', '18812349901', NULL, NULL, NULL, '正常', 1639882283477, 4);
INSERT INTO `base_account` VALUES (35, '张小龙', '123321', '张小龙', '18812340001', NULL, NULL, NULL, '正常', 1639970383923, 4);
INSERT INTO `base_account` VALUES (36, '张铭', '123321', '张铭', '18812340002', NULL, NULL, NULL, '正常', 1639970572964, 4);
INSERT INTO `base_account` VALUES (37, '李璐', '123321', '李璐', '18812340003', NULL, NULL, NULL, '正常', 1639988508606, 4);
INSERT INTO `base_account` VALUES (38, 'worker', '123321', '工人一号', '18812344400', 'male', 1640016000000, 'http://121.199.29.84:8888/group1/M00/00/A1/rBD-SWHBl02ANMQ2AABMxFgBI4s651.jpg', '正常', 1640049064521, 13);
INSERT INTO `base_account` VALUES (39, 'worker2', '123321', '工人2号', '18812340008', 'male', 944582400000, NULL, '正常', 1640076068779, 13);
COMMIT;

-- ----------------------------
-- Table structure for base_config
-- ----------------------------
DROP TABLE IF EXISTS `base_config`;
CREATE TABLE `base_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '配置名称',
  `value` varchar(255) NOT NULL,
  `introduce` varchar(255) DEFAULT NULL COMMENT '简介',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_config
-- ----------------------------
BEGIN;
INSERT INTO `base_config` VALUES (1, 'logo', 'http://121.199.29.84:8888/group1/M00/00/9F/rBD-SWGwg-yADOPOAABrMGeCo1A040.jpg', '系统logo');
INSERT INTO `base_config` VALUES (2, 'name', '智慧城市环境监测系统', '项目名称');
INSERT INTO `base_config` VALUES (3, 'copyright', '上海杰普软件科技有限公司 沪ICP备07000318号-1', '版权');
INSERT INTO `base_config` VALUES (5, 'address', '江苏省苏州市昆山市巴城镇学院路828号', '地址');
COMMIT;

-- ----------------------------
-- Table structure for base_privilege
-- ----------------------------
DROP TABLE IF EXISTS `base_privilege`;
CREATE TABLE `base_privilege` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `route` varchar(255) NOT NULL,
  `route_name` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `hidden` int(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL COMMENT '序号',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父栏目ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_privilege
-- ----------------------------
BEGIN;
INSERT INTO `base_privilege` VALUES (6, '角色权限', '', '/sys/', 'Role', 'menu', 'icon_5', 0, 1, NULL);
INSERT INTO `base_privilege` VALUES (7, '权限管理', '', '/sys/privilege/List', '', 'menu', '', 0, 0, 6);
INSERT INTO `base_privilege` VALUES (8, '用户管理', '', '/sys/user/List', '0', 'menu', '', 0, 0, 6);
INSERT INTO `base_privilege` VALUES (9, '角色管理', '', '/sys/role/List', '', 'menu', '', 0, 0, 6);
INSERT INTO `base_privilege` VALUES (13, '工程设备', '', '/am/engineer', '', 'menu', 'icon_2', 0, 9, NULL);
INSERT INTO `base_privilege` VALUES (14, '工程管理', NULL, '/am/engineer/List', NULL, 'menu', NULL, 0, 0, 13);
INSERT INTO `base_privilege` VALUES (15, '设备管理', NULL, '/am/device/List', NULL, 'menu', NULL, 0, 0, 13);
INSERT INTO `base_privilege` VALUES (17, '监测数据', NULL, '/am/monitor', NULL, 'menu', 'icon_4', 0, 7, NULL);
INSERT INTO `base_privilege` VALUES (19, '实时监测', NULL, '/am/monitor/RealTime', NULL, 'menu', '0', 0, 0, 17);
INSERT INTO `base_privilege` VALUES (20, '监测月报', NULL, '/am/monitor/Monthly', NULL, 'menu', '0', 0, 0, 17);
INSERT INTO `base_privilege` VALUES (23, '历史数据', '', '/am/monitor/History', '', 'menu', '0', 0, 0, 17);
INSERT INTO `base_privilege` VALUES (25, '监测视频', '', '/am/monitor/Video', '', 'menu', '0', 0, 0, 17);
INSERT INTO `base_privilege` VALUES (26, '监测点信息', '', '/am/monitor/PointInfo', '', 'menu', '0', 0, 0, 17);
INSERT INTO `base_privilege` VALUES (27, '工程详情', NULL, '/am/engineer/Details', NULL, 'menu', NULL, 1, NULL, 13);
INSERT INTO `base_privilege` VALUES (28, '基础配置', NULL, '/sys/config', NULL, 'menu', 'icon_3', 0, 0, NULL);
INSERT INTO `base_privilege` VALUES (29, '系统配置', NULL, '/sys/config/List', NULL, 'menu', NULL, 0, NULL, 28);
INSERT INTO `base_privilege` VALUES (30, '个人信息', NULL, '/sys/user/Personal', NULL, 'menu', NULL, 0, NULL, 28);
INSERT INTO `base_privilege` VALUES (31, '工单管理', NULL, '/am/order', NULL, 'menu', 'icon_8', 0, 8, NULL);
INSERT INTO `base_privilege` VALUES (32, '工单列表', NULL, '/am/order/List', NULL, 'menu', NULL, 0, NULL, 31);
INSERT INTO `base_privilege` VALUES (33, '我要报修', NULL, '/am/order/Repairs', NULL, 'menu', NULL, 0, NULL, 31);
INSERT INTO `base_privilege` VALUES (35, '工程管理', NULL, '/pds/engineer/List', NULL, 'menu', NULL, 0, NULL, 34);
INSERT INTO `base_privilege` VALUES (36, '设备管理', NULL, '/pds/device/List', NULL, 'menu', NULL, 0, NULL, 34);
INSERT INTO `base_privilege` VALUES (38, '工程详情', NULL, '/pds/engineer/Details', NULL, 'menu', NULL, 1, NULL, 34);
INSERT INTO `base_privilege` VALUES (39, '用户详情', NULL, '/sys/user/Details', NULL, 'menu', NULL, 1, NULL, 6);
INSERT INTO `base_privilege` VALUES (42, '工单详情', NULL, '/am/order/Details', NULL, 'menu', NULL, 1, NULL, 31);
INSERT INTO `base_privilege` VALUES (43, '学生选课', NULL, '/sc', NULL, 'menu', 'icon_18', 0, 5, NULL);
INSERT INTO `base_privilege` VALUES (44, '学生管理', NULL, '/sc/student/List', NULL, 'menu', NULL, 0, NULL, 43);
INSERT INTO `base_privilege` VALUES (45, '课程管理', NULL, '/sc/course/List', NULL, 'menu', NULL, 0, NULL, 43);
INSERT INTO `base_privilege` VALUES (46, '学生档案', NULL, '/sc/student/Details', NULL, 'menu', NULL, 1, NULL, 43);
COMMIT;

-- ----------------------------
-- Table structure for base_role
-- ----------------------------
DROP TABLE IF EXISTS `base_role`;
CREATE TABLE `base_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '角色名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_role
-- ----------------------------
BEGIN;
INSERT INTO `base_role` VALUES (1, '管理员');
INSERT INTO `base_role` VALUES (3, '区域经理');
INSERT INTO `base_role` VALUES (4, '客户');
INSERT INTO `base_role` VALUES (13, '工人');
COMMIT;

-- ----------------------------
-- Table structure for base_role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `base_role_privilege`;
CREATE TABLE `base_role_privilege` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `privilege_id` bigint(20) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`),
  KEY `base_role_privilege_ibfk_3` (`role_id`),
  KEY `base_role_privilege_ibfk_4` (`privilege_id`),
  CONSTRAINT `base_role_privilege_ibfk_3` FOREIGN KEY (`role_id`) REFERENCES `base_role` (`id`) ON DELETE CASCADE,
  CONSTRAINT `base_role_privilege_ibfk_4` FOREIGN KEY (`privilege_id`) REFERENCES `base_privilege` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=521 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of base_role_privilege
-- ----------------------------
BEGIN;
INSERT INTO `base_role_privilege` VALUES (76, 3, 13);
INSERT INTO `base_role_privilege` VALUES (77, 3, 14);
INSERT INTO `base_role_privilege` VALUES (78, 3, 15);
INSERT INTO `base_role_privilege` VALUES (80, 3, 27);
INSERT INTO `base_role_privilege` VALUES (387, 4, 23);
INSERT INTO `base_role_privilege` VALUES (388, 4, 17);
INSERT INTO `base_role_privilege` VALUES (390, 4, 19);
INSERT INTO `base_role_privilege` VALUES (391, 4, 20);
INSERT INTO `base_role_privilege` VALUES (392, 4, 25);
INSERT INTO `base_role_privilege` VALUES (393, 4, 26);
INSERT INTO `base_role_privilege` VALUES (394, 4, 28);
INSERT INTO `base_role_privilege` VALUES (395, 4, 29);
INSERT INTO `base_role_privilege` VALUES (396, 4, 30);
INSERT INTO `base_role_privilege` VALUES (407, 13, 33);
INSERT INTO `base_role_privilege` VALUES (408, 13, 28);
INSERT INTO `base_role_privilege` VALUES (409, 13, 31);
INSERT INTO `base_role_privilege` VALUES (410, 13, 29);
INSERT INTO `base_role_privilege` VALUES (411, 13, 32);
INSERT INTO `base_role_privilege` VALUES (495, 1, 13);
INSERT INTO `base_role_privilege` VALUES (496, 1, 6);
INSERT INTO `base_role_privilege` VALUES (497, 1, 14);
INSERT INTO `base_role_privilege` VALUES (498, 1, 15);
INSERT INTO `base_role_privilege` VALUES (499, 1, 27);
INSERT INTO `base_role_privilege` VALUES (500, 1, 7);
INSERT INTO `base_role_privilege` VALUES (501, 1, 8);
INSERT INTO `base_role_privilege` VALUES (502, 1, 9);
INSERT INTO `base_role_privilege` VALUES (503, 1, 39);
INSERT INTO `base_role_privilege` VALUES (504, 1, 17);
INSERT INTO `base_role_privilege` VALUES (505, 1, 19);
INSERT INTO `base_role_privilege` VALUES (506, 1, 20);
INSERT INTO `base_role_privilege` VALUES (507, 1, 23);
INSERT INTO `base_role_privilege` VALUES (508, 1, 25);
INSERT INTO `base_role_privilege` VALUES (509, 1, 26);
INSERT INTO `base_role_privilege` VALUES (510, 1, 28);
INSERT INTO `base_role_privilege` VALUES (511, 1, 29);
INSERT INTO `base_role_privilege` VALUES (512, 1, 32);
INSERT INTO `base_role_privilege` VALUES (513, 1, 30);
INSERT INTO `base_role_privilege` VALUES (514, 1, 33);
INSERT INTO `base_role_privilege` VALUES (515, 1, 31);
INSERT INTO `base_role_privilege` VALUES (516, 1, 42);
INSERT INTO `base_role_privilege` VALUES (517, 1, 44);
INSERT INTO `base_role_privilege` VALUES (518, 1, 43);
INSERT INTO `base_role_privilege` VALUES (519, 1, 45);
INSERT INTO `base_role_privilege` VALUES (520, 1, 46);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
